Investor's dream! Step into stunning with this incredible opportunity just minutes from Niagara Falls, Clifton Hill, casinos, golf, and Niagara’s wine country. Offering 6 bedrooms, 3 full baths, 2 kitchens (rough-in for third kitchen on 2nd floor!) and an in-law basement 2 bed suite, this property features 2 fully self-contained units with separate entrances and hydro meters, creating outstanding income potential or an ideal multigenerational setup. The open-concept main floor showcases a brand-new kitchen (2022) with quartz countertops, a dining/living area with custom brick gas fireplace, and a hand-crafted black locust mantle. All four levels have been meticulously renovated top to bottom, with new insulation, updated plumbing and electrical, owned tankless water heater, and a new A/C (2025). Exterior upgrades include new siding, roof, windows, and doors (2020), plus a new front porch and stairs (2025). The exposed aggregate wraparound driveway and walkway (2022) lead to a large deck overlooking the private fenced yard. A detached 1.5-car garage with wood stove and attic, plus shed and garden space add even more value. Easy to convert back to a single-family or multi-generational home, this property is a rare blend of character, function, and opportunity. A must-see to truly appreciate.